3 visuals for webpage

This code will help produce the three visuals that are going to be a part of each equity tracker indicator webpage: regional map (tract level) of most recent data, chart of the most recent data, chart of trends over time.

If the indicator is available through a tract-level data set. Getting the data to a workable version may require some data transformation. To explore, clean, transform, and generate a final data set, please use the data-gen-tract-template. This script will generate an .rda for the map and an .rda for the charts. These data sets will be loaded in before the data visualization code.

Indicator Explanation

The rate of incarcerated individuals in Washington State prisons per 100,000 residents by census tract, based on each incarcerated person’s last known address. Understanding where incarcerated individuals come from can help us understand which communities are disproportionately impacted so better policies can be created to change negative outcomes.

1. Map of most recent data

To map data in this form, there should be a value corresponding to each census tract. Depending on the year or source of the data, this could be about 700 rows for data at the 2010 census tract resolution, or about 900 rows for data at the 2020 census tract resolution.

The map scale has been adjusted to the natural log of the rate to make the map colors meaningful.

Create Visual

Sources: Prison Policy Initiative analyzing data provided by Washington State Department of Corrections, 2020; U.S. Census Bureau, 2016-2020 American Community Survey 5-Year Estimates, Table B01003; U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles * Note: color ramp uses log scale


Data call outs

  1. 180: The region’s average imprisonment rate
  2. 200: Washington State’s average imprisonment rate
  3. 276: Number of census tracts in the region above the region’s average imprisonment rate

Insights & Analysis

  • The four census tracts with the highest average imprisonment rates all include large facilities such as jails or Harborview Medical Center, which may indicate that these places were used as last known addresses for some incarcerated individuals
  • The census tracts with the highest imprisonment rate are Downtown Tacoma, Pierce County (8006); Yesler Terrace area of Seattle, King County (5127); Port of Tacoma area, Pierce County (4624); Downtown Everett, Snohomish County (3608)
  • Pierce County has the highest average imprisonment rate (285), followed by Kitsap (231), Snohomish (158), and King (139)
  • There are 99 census tracts with an imprisonment rate of zero in the region. For Pierce County, 3% of census tracts (6) have a rate of zero for imprisonment, followed by Kitsap with 5% (3), Snohomish with 6% (10), and then King county with 16% (80).

2. Facet of most recent data

Create Visual

Imprisonment

Rate per 100,000 residents

Prison Policy Initiative analyzing data provided by Washington State Department of Corrections, 2020 U.S. Census Bureau, 2016-2020 American Community Survey 5-Year Estimates, Table B01003 U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)


Data Call Outs

  1. 8x: As a region, communities with high concentrations of households with lower income have almost eight times higher imprisonment rate
  2. 5x higher: As a region, communities with high concentrations of people with disabilities have five times higher imprisonment rate
  3. 2x: Pierce County has almost twice the imprisonment rate as the region for communities with high concentrations of households with people of color or lower income

Insights & Analysis

  • Communities with high concentrations of households with lower income or people with disabilities are most disproportionately impacted by imprisonment
  • Pierce County has the highest imprisonment rate (713) for communities with high concentration of households with lower income, followed by Kitsap (493), Snohomish (321), and King (267); the average rate for high concentration of households with lower income across the Region is 383
  • The highest imprisonment rate for communities with high concentration of people with disabilities is Pierce County (451), followed by Kitsap (312), King (221), Snohomish (318); the average rate for high concentration of people with disabilities across the Region is 326 and the rate for the Region is 326

This dataset first became available in 2020 due to a change in Washington State law requiring the Department of Corrections to report last known addresses for people incarcerated in state prisons during the 2020 Decennial Census. At this time, 2020 is the only year available and it is unclear if this data will be available again after the 2030 Decennial Census.

3. Facet of trend data

Create Visual

Imprisonment

Rate per 100,000 residents

Prison Policy Initiative analyzing data provided by Washington State Department of Corrections, 2020 U.S. Census Bureau, 2016-2020 American Community Survey 5-Year Estimates, Table B01003 U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)



Transfer files

Copy files from Github > Y drive

Copy files from Y drive > website folder

Back to top of the page